Columns
Indexes
Grants
Dependencies
Details
Columns
Indexes
Grants
Dependencies
Details
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
SID | NUMBER | No | null | 1 | null |
OBJ | VARCHAR2(20 BYTE) | No | null | 2 | null |
ID | VARCHAR2(100 BYTE) | No | null | 3 | null |
TITLE | VARCHAR2(100 BYTE) | No | null | 4 | null |
INVESTIGATION_TYPE | VARCHAR2(108 BYTE) | Yes | null | 5 | null |
THREAT_CATEGORY | VARCHAR2(108 BYTE) | Yes | null | 6 | null |
REC_DISPOSITION | VARCHAR2(108 BYTE) | Yes | null | 7 | null |
DISPOSITION | VARCHAR2(108 BYTE) | Yes | null | 8 | null |
RESOLUTION | VARCHAR2(108 BYTE) | Yes | null | 9 | null |
INCIDENT_LOCATION | VARCHAR2(108 BYTE) | Yes | null | 10 | null |
INDEX_OWNER | INDEX_NAME | COLUMNS | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | COLUMN_EXPRESSION | JOIN_INDEX |
---|---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_OBJ | OBJ | NONUNIQUE | VALID | NORMAL | N | NO | null | null | NO |
QART | IDX_MV_F_THREAT_INVEST_SID | SID | NONUNIQUE | VALID | NORMAL | N | NO | null | null | NO |
QART | IDX_MV_F_THREAT_INVEST_RESOLUTION | RESOLUTION | NONUNIQUE | VALID | NORMAL | N | NO | null | null | NO |
QART | IDX_MV_F_THREAT_INVEST_DISPOSITION | DISPOSITION | NONUNIQUE | VALID | NORMAL | N | NO | null | null | NO |
QART | IDX_MV_F_THREAT_INVEST_REC_DISPOSITION | REC_DISPOSITION | NONUNIQUE | VALID | NORMAL | N | NO | null | null | NO |
QART | IDX_MV_F_THREAT_INVEST_THREAT_CATEGORY | THREAT_CATEGORY | NONUNIQUE | VALID | NORMAL | N | NO | null | null | NO |
QART | IDX_MV_F_THREAT_INVEST_INVESTIGATION_TYPE | INVESTIGATION_TYPE | NONUNIQUE | VALID | NORMAL | N | NO | null | null | NO |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID |
---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_OBJ | QART | MV_F_THREAT_INVEST | OBJ | 1 | 20 | 20 | ASC | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID |
---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_SID | QART | MV_F_THREAT_INVEST | SID | 1 | 22 | 0 | ASC | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID |
---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_RESOLUTION | QART | MV_F_THREAT_INVEST | RESOLUTION | 1 | 108 | 108 | ASC | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID |
---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_DISPOSITION | QART | MV_F_THREAT_INVEST | DISPOSITION | 1 | 108 | 108 | ASC | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID |
---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_REC_DISPOSITION | QART | MV_F_THREAT_INVEST | REC_DISPOSITION | 1 | 108 | 108 | ASC | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID |
---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_THREAT_CATEGORY | QART | MV_F_THREAT_INVEST | THREAT_CATEGORY | 1 | 108 | 108 | ASC | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID |
---|---|---|---|---|---|---|---|---|---|
QART | IDX_MV_F_THREAT_INVEST_INVESTIGATION_TYPE | QART | MV_F_THREAT_INVEST | INVESTIGATION_TYPE | 1 | 108 | 108 | ASC | null |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OBJECT_ID | OWNER | OBJECT_TYPE | OBJECT_NAME | STATUS | TYPE_LINK |
---|
References
NAME | VALUE |
---|---|
CREATED | 03-FEB-25 |
LAST_DDL_TIME | 03-FEB-25 |
OWNER | QART |
MVIEW_NAME | MV_F_THREAT_INVEST |
CONTAINER_NAME | MV_F_THREAT_INVEST |
QUERY | SELECT SID, OBJ, ID, TITLE, INVESTIGATION_TYPE, THREAT_CATEGORY, REC_DISPOSITION, DISPOSITION, RESOLUTION, INCIDENT_LOCATION FROM ACM.T_F_THREAT_INVEST |
QUERY_LEN | 171 |
UPDATABLE | N |
UPDATE_LOG | null |
MASTER_ROLLBACK_SEG | null |
MASTER_LINK | null |
REWRITE_ENABLED | N |
REWRITE_CAPABILITY | GENERAL |
REFRESH_MODE | DEMAND |
REFRESH_METHOD | COMPLETE |
BUILD_MODE | IMMEDIATE |
FAST_REFRESHABLE | DIRLOAD_DML |
LAST_REFRESH_TYPE | COMPLETE |
LAST_REFRESH_DATE | 03-FEB-25 |
LAST_REFRESH_END_TIME | 03-FEB-25 |
STALENESS | FRESH |
AFTER_FAST_REFRESH | FRESH |
UNKNOWN_PREBUILT | N |
UNKNOWN_PLSQL_FUNC | N |
UNKNOWN_EXTERNAL_TABLE | N |
UNKNOWN_CONSIDER_FRESH | N |
UNKNOWN_IMPORT | N |
UNKNOWN_TRUSTED_FD | N |
COMPILE_STATE | VALID |
USE_NO_INDEX | Y |
STALE_SINCE | null |
NUM_PCT_TABLES | 0 |
NUM_FRESH_PCT_REGIONS | null |
NUM_STALE_PCT_REGIONS | null |
SEGMENT_CREATED | YES |
EVALUATION_EDITION | null |
UNUSABLE_BEFORE | null |
UNUSABLE_BEGINNING | null |
DEFAULT_COLLATION | USING_NLS_COMP |
ON_QUERY_COMPUTATION | N |
DUPLICATED | N |
SHARDED | N |